package com.dgut.hisystem.service;

import com.dgut.hisystem.entity.Advice;
import com.dgut.hisystem.entity.Drug;
import com.dgut.hisystem.entity.VO.PrescriptionVO;
import com.dgut.hisystem.entity.VO.SimpleDrug;

import java.sql.Timestamp;
import java.util.List;

public interface DrugService {
    List<Drug> getAll();
    List<Drug> getExpDrug();
    List<Drug> getDrug(long id);
    Drug getDrugById(long id);
    Drug getDrugByName(String name);
    void delete(Integer id);
    void updatePrice(Integer id, Double price);
    void updateAmount(Integer id, Integer amount);
    void insertDrug(Drug d);
    List<PrescriptionVO> selectAllPrescription();

    List<SimpleDrug> drugOutStorage(long cf_id);

    long SelectBrcardByBlid(long bl_id);

    long SelectYsidByBlid(long bl_id);

    long selectYhidByBrcard(long bl_card);

    String selectYsofficeByYsid(long ys_id);

    long selectYhidByYsid(long ys_id);

    String selectYhnameByYhid(long yh_id);

    Advice selectAdviceById(Integer id);


}
